Obtain the date of a week based on a week of a year. For example, if the start date is set to "Thursday" to "Friday" of the next week, you can refer to the following requirements when getting the JS date: Obtain the date of the week based on a week
Transferred from: http://www.cnblogs.com/likwo/archive/2010/04/16/1713282.htmlQuery Day:SELECT * FROM table where to_days (column_time) = To_days (now ());SELECT * FROM table where date (column_time) = Curdate ();Query one week:SELECT * FROM table
Obtain the date range of the week based on the time range of the week.Obtain the date range of the week according to the week
/*** Return the range of Weekly Times of a month in a certain year * @ param weeks Weekly Times * @ return the range of
Function
/*
Every function has only one sentence!
In fact, from another blog I dug out:
T-SQL generates two new true Gregorian calendars
Http://blog.csdn.net/playyuer/archive/2004/04/07/2860.aspx
T-SQL generates a simple Gregorian calendar T-SQL
Query Day:Select * from Table where = To_days (now ()); Select * from Table where =Query one week:Select * from Table where 7 Day Date (column_time);Query one months:Select * from Table where 1 MONTH Date (column_time);MySQL date and time
When JS obtains a date, it encounters the following requirement: Obtain the date of a week based on a week of a year. For example, the start date must be from Thursday to Friday of the next week.
The Code is as follows:
Function getNowFormatDate
Take the first day of the week the first day of the week is the week
* Set the first day of the week is the week* @param string $week Week 0-6* @return void*/Public Function Setfirstdayofweek ($week = 1) {$this->firstdayofweek = $week;}
/*** Take
Get day of the week, date get week, time get week, JS get week based on date string>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>.Sweet Potato Yiu December 30, 2016 08:47:38 Fridayhttp://www.cnblogs.com/fanshuyao//** * Gets the day of the week based on the
Obtain the date range of the week according to the weekObtain the date range of the week according to the week
/*** Return the range of Weekly Times of a month in a certain year * @ param weeks Weekly Times * @ return the range of dates of the
Kimlarsson calculation formula determines the day
of the week by the date calculateweekday (int y, int m,int d) {
if (m==1| | m==2) m+=12,y--;
int iweek = (d+2*m+3* (m+1)/5+y+y/4-y/100+y/400)%7;
Switch (iweek) {case
0:printf ("Monday \ n");
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.